AnnualIncomeRange

Entity Definition

Logical Name : AnnualIncomeRange
Physical Name : LU_ANN_INCM_RNGE

A reference entity type that lists annual income range codes used by the retailer for segementing consumers/customers.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AnnualIncomeRangeCode (PK) Code that defines a high-low range of annual income for a consumer. CD_ANN_INCM_RNGE Code varchar(20)
HighIncomeValue High income value used to define a named annual income range for customer segmentation. MO_HIGH_INCM_VL Money decimal(16,5)
LowIncomeValue Low income value used to define a named annual income range for customer segmentation. MO_LW_INCM_VL Money decimal(16,5)
CurrencyID (FK) The unique identifier of the Currency. ID_CNY Identity integer Currency(CO_CNY)
ISOCurrencyCode (FK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)

Relationships

Parent Entity Verb Phrase Child Entity
Currency defines measure of AnnualIncomeRange
ISO4217-CurrencyType is used in AnnualIncomeRange
AnnualIncomeRange defines Person
AnnualIncomeRange characterizes CompositeDemographicSegment

Logical Views containing AnnualIncomeRange

Logical View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10104 - Enterprise Currency